﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.Master" AutoEventWireup="true" CodeBehind="SelectScoreInfo.aspx.cs" Inherits="Web2014112110.SelectScoreInfo1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <asp:Image ID="Image2" runat="server" Height="39px" ImageUrl="~/Images/ae.jpg" Width="42px" />
    <asp:Label ID="lblTitle0" runat="server" Font-Bold="False" Font-Names="华文琥珀" Font-Size="XX-Large" ForeColor="#000066" style="text-align: left" Text="学生信息管理系统"></asp:Label>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    <asp:Label ID="lblUser" runat="server" Font-Bold="False" Font-Names="楷体" Font-Size="Medium" ForeColor="#000066" style="text-align: left" Text="当前登录用户："></asp:Label>
    <asp:Label ID="lblNowUser" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="Medium" ForeColor="#000066"></asp:Label>
    <asp:Label ID="lblType" runat="server" Font-Bold="False" Font-Names="楷体" Font-Size="Medium" ForeColor="#000066" Text="用户类型："></asp:Label>
    <asp:Label ID="lblUserType" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="Medium" ForeColor="#000066">教师</asp:Label>
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="ContentPlaceHolder3" runat="server">
    <p>
        <asp:TreeView ID="TreeView1" runat="server" DataSourceID="SiteMapDataSource1" ShowLines="True" Font-Bold="True" Font-Names="楷体" Font-Size="Large" ForeColor="#000066">
        </asp:TreeView>
        <asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" SiteMapProvider="web2"/>
    </p>
    <p>
        <asp:Label ID="userName" runat="server" Font-Bold="True" Font-Italic="False" Font-Names="楷体" Font-Size="Medium" ForeColor="#3333CC"></asp:Label>
    </p>
    <p>
        <asp:Image ID="Image" runat="server" Height="87px" ImageUrl="~/Images/a.jpg" Width="87px" ImageAlign="Middle" />
    </p>
</asp:Content>
<asp:Content ID="Content5" ContentPlaceHolderID="ContentPlaceHolder5" runat="server">
    <asp:Label ID="lblCopyright" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="Medium" ForeColor="#000066" Text="Number：@2014112110；Name：@林丽鸿"></asp:Label>
</asp:Content>
<asp:Content ID="Content6" ContentPlaceHolderID="ContentPlaceHolder4" runat="server">
    <p style="text-align: left">
        &nbsp;</p>
    <p style="text-align: center">
        <asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="X-Large" ForeColor="#006699" Text="查询学生成绩"></asp:Label>
&nbsp;
        <asp:HyperLink ID="HyperLink1" runat="server" Font-Bold="True" Font-Italic="True" Font-Names="楷体" Font-Size="Large" Font-Underline="True" ForeColor="#66CCFF" NavigateUrl="~/AddScoreInfo.aspx">录入学生成绩</asp:HyperLink>
&nbsp;
        <asp:HyperLink ID="HyperLink2" runat="server" Font-Bold="True" Font-Italic="True" Font-Names="楷体" Font-Size="Large" Font-Underline="True" ForeColor="#66CCFF" NavigateUrl="~/DeleteStuInfo.aspx">删除学生成绩</asp:HyperLink>
&nbsp;
        <asp:HyperLink ID="HyperLink3" runat="server" Font-Bold="True" Font-Italic="True" Font-Names="楷体" Font-Size="Large" Font-Underline="True" ForeColor="#66CCFF" NavigateUrl="~/UpdateScoreInfo.aspx">更新学生成绩</asp:HyperLink>
    </p>
    <p style="text-align: center">
        <asp:Label ID="lblTitle" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="X-Large" ForeColor="#000066" Text="按学号查询每科成绩"></asp:Label>
    </p>
    <p style="text-align: center">
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
        <asp:Label ID="lblNo" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="Large" ForeColor="#000066" Text="请输入学号："></asp:Label>
        <asp:TextBox ID="txtNo" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="Medium" Font-Underline="False" ForeColor="#000066" Width="138px"></asp:TextBox>
    &nbsp;&nbsp;&nbsp;
        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtNo" ErrorMessage="RequiredFieldValidator" Font-Bold="True" Font-Italic="True" Font-Names="楷体" Font-Size="Medium" ForeColor="#FF5050">需输入学生学号</asp:RequiredFieldValidator>
    </p>
    <p style="text-align: center">
        <asp:Button ID="btnSelect" runat="server" Font-Bold="True" Font-Names="楷体" Font-Size="Large" ForeColor="#000066" style="height: 28px" Text="查询" />
    </p>
    <p style="text-align: center">
        &nbsp;</p>
    <p style="text-align: center">
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="No,ClassName" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" PageSize="7" style="margin-left: 273px" Width="401px">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <Columns>
                <asp:BoundField DataField="No" HeaderText="学号" ReadOnly="True" SortExpression="No" />
                <asp:BoundField DataField="Name" HeaderText="姓名" SortExpression="Name" />
                <asp:BoundField DataField="CollegeName" HeaderText="学院" SortExpression="CollegeName" />
                <asp:BoundField DataField="ClassName" HeaderText="课程" ReadOnly="True" SortExpression="ClassName" />
                <asp:BoundField DataField="Score" HeaderText="分数" SortExpression="Score" />
            </Columns>
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112110ConnectionString %>" SelectCommand="SELECT * FROM [ScoreInfo] WHERE ([No] = @No)">
            <SelectParameters>
                <asp:ControlParameter ControlID="txtNo" Name="No" PropertyName="Text" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
    <p style="text-align: center">
        &nbsp;</p>
</asp:Content>
